<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-15">
<style>
      .table {
        background-color:#F5F5FF;
        border-left:4px solid gray;
        border-bottom:4px solid gray;
        border-top:4px solid gray;
        border-right:4px solid gray;
        margin-bottom:3em;
        margin-left:2em;
        margin-right:2em;
        padding:1em;
      }
      .tableNameHeading h1 {
          display: inline;
        font-family: Segoe UI, Arial, sans-serif;
        font-size:125%;
        font-weight:bold;
      }
        
      .tableNameHeading h2 {
        display: inline;
        font-family: Segoe UI, Arial, sans-serif;
        font-size:115%;
        font-weight:normal;
      }
      
      .tableComment { 
        background-color:#e4efff; margin-bottom:20px;
      }
      
      .tableDefinition { 
        padding:2px;
        border-collapse:collapse;
        margin-top:1em;
      }

      .tdTableDefinition {
        padding-right:10px;
        vertical-align:top;
        border-top:1px solid #C0C0C0;
      }

      .tdLogicalColName {
        width:20em;
      }
      
      .tdPhysicalColName {
        width:20em;
      }
      
      .tdDataType {
        width:10em;
      }

      .tdPkFlag {
        width:4em;
      }

      .tdNullFlag {
        width:9em;
      }

      .tdTableHeading {
        padding:2px;
        font-family: Segoe UI, Arial, sans-serif;
        font-weight: bold;
        vertical-align:top;
        border-bottom: 1px solid #C0C0C0;
        background-color: rgb(240,240,240);
      }
      
      .subTitle {
        font-family: Segoe UI, Arial, sans-serif;
        font-weight: bold;
      }

      .references {
      }
      .comment {
        color:#666666;
        margin-left:3em;
        padding:0.25em;
      }
    </style>
<title>data-model</title>
</head>
<body>
<center>
<h2>data-model</h2>
</center>
<h3>List of tables</h3>
<ul>
<li>
<a href="#Contact">Contact</a>
</li>
<li>
<a href="#Order">Order</a>
</li>
<li>
<a href="#OrderItem">OrderItem</a>
</li>
<li>
<a href="#OrderItemHist">OrderItemHist</a>
</li>
<li>
<a href="#Product">Product</a>
</li>
<li>
<a href="#ProductSpecification">ProductSpecification</a>
</li>
<li>
<a href="#ProductSpecProperty">ProductSpecProperty</a>
</li>
</ul>
<div class="tableNameHeading">
<h1>Contact<a name="Contact"></a>
</h1>
<h2>
      (Physical Name: TBL_CONTACT)
      </h2>
<p class="comment">information for a contact</p>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">id (PK)</td><td class="tdTableDefinition">CONTACT_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr>
<td colspan="4">
<div class="comment">unique ID of a contact</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">name</td><td class="tdTableDefinition">DISPLAY_NAME</td><td class="tdTableDefinition">VARCHAR(200)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">display contact name (full-name if 'invidual')</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">description</td><td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">VARCHAR(500)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">optional description about this contact</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">type</td><td class="tdTableDefinition">CONTACT_TYPE</td><td class="tdTableDefinition">VARCHAR(30)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr>
<td colspan="4">
<div class="comment">contact type, mapped to Java ENUM</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">scope</td><td class="tdTableDefinition">CONTACT_SCOPE</td><td class="tdTableDefinition">VARCHAR(30)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">email2</td><td class="tdTableDefinition">EMAIL_ADDRESS_2</td><td class="tdTableDefinition">VARCHAR(100)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">secondary email address</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">phone1</td><td class="tdTableDefinition">PHONE_1</td><td class="tdTableDefinition">VARCHAR(20)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">main phone number, required</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">address2</td><td class="tdTableDefinition">ADDRESS_2</td><td class="tdTableDefinition">VARCHAR(300)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">secondary address</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">mobilePhone</td><td class="tdTableDefinition">MOBILE</td><td class="tdTableDefinition">VARCHAR(20)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">mobile phone number</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">address1</td><td class="tdTableDefinition">ADDRESS_1</td><td class="tdTableDefinition">VARCHAR(300)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">phone2</td><td class="tdTableDefinition">PHONE_2</td><td class="tdTableDefinition">VARCHAR(20)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">secondary phone number</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">fax</td><td class="tdTableDefinition">FAX</td><td class="tdTableDefinition">VARCHAR(20)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">FAX number</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">email1</td><td class="tdTableDefinition">EMAIL_ADDRESS_1</td><td class="tdTableDefinition">VARCHAR(100)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr>
<td colspan="4">
<div class="comment">main email address</div>
</td>
</tr>
</table>
<div class="references">
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#Order">Order</a> referencing (id)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>Order<a name="Order"></a>
</h1>
<h2>
      (Physical Name: TBL_ORDER)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">id (PK)
                &nbsp;(<a href="#Contact">FK</a>)
              </td><td class="tdTableDefinition">ORDER_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr>
<td colspan="4">
<div class="comment">unique ID of a order</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">name</td><td class="tdTableDefinition">DISPLAY_NAME</td><td class="tdTableDefinition">VARCHAR(200)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">display contact name (full-name if 'invidual')</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">contact</td><td class="tdTableDefinition">CONTACT_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">description</td><td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">VARCHAR(500)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">optional description about this contact</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">deliveryDate</td><td class="tdTableDefinition">DELIVERY_DATE</td><td class="tdTableDefinition">DATE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">creationDate</td><td class="tdTableDefinition">CREATION_DATE</td><td class="tdTableDefinition">DATE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">expiryDate</td><td class="tdTableDefinition">EXPIRY_DATE</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">remindBefore</td><td class="tdTableDefinition">REMIND_BEFORE</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">the interval before the real expiry date which the user wants the system to remind him about the deadline</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">status</td><td class="tdTableDefinition">STATUS</td><td class="tdTableDefinition">VARCHAR(30)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
</table>
<div class="references">
<p class="subTitle">References</p>
<ul>
<li>
<a href="#Contact">Contact</a> through (id)</li>
</ul>
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#OrderItem">OrderItem</a> referencing (id)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>OrderItem<a name="OrderItem"></a>
</h1>
<h2>
      (Physical Name: TBL_ORDER_ITEM)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">id (PK)
                &nbsp;(<a href="#Product">FK</a>)
              
                &nbsp;(<a href="#Order">FK</a>)
              </td><td class="tdTableDefinition">ORDER_ITEM_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr>
<td colspan="4">
<div class="comment">unique ID of a order item</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">name</td><td class="tdTableDefinition">DISPLAY_NAME</td><td class="tdTableDefinition">VARCHAR(200)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">display contact name (full-name if 'invidual')</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">order</td><td class="tdTableDefinition">ORDER_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">description</td><td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">VARCHAR(500)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">optional description about this contact</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">quantity</td><td class="tdTableDefinition">QUANTITY</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">nailed</td><td class="tdTableDefinition">NAILED</td><td class="tdTableDefinition">CHAR</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">stuck</td><td class="tdTableDefinition">STUCK</td><td class="tdTableDefinition">CHAR</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">product</td><td class="tdTableDefinition">PRODUCT_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">held</td><td class="tdTableDefinition">HELD</td><td class="tdTableDefinition">CHAR</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">specialRequest</td><td class="tdTableDefinition">SPECIAL_REQUEST</td><td class="tdTableDefinition">VARCHAR(100)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">deliveryDate</td><td class="tdTableDefinition">DELIVERY_DATE</td><td class="tdTableDefinition">DATE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">startDate</td><td class="tdTableDefinition">START_DATE</td><td class="tdTableDefinition">DATE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">expiryDate</td><td class="tdTableDefinition">EXPIRY_DATE</td><td class="tdTableDefinition">DATE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">remindBefore</td><td class="tdTableDefinition">REMIND_BEFORE</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">the interval before the real expiry date which the user wants the system to remind him about the deadline</div>
</td>
</tr>
</table>
<div class="references">
<p class="subTitle">References</p>
<ul>
<li>
<a href="#Product">Product</a> through (id)</li>
<li>
<a href="#Order">Order</a> through (id)</li>
</ul>
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#OrderItemHist">OrderItemHist</a> referencing (id)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>OrderItemHist<a name="OrderItemHist"></a>
</h1>
<h2>
      (Physical Name: TBL_ORDER_ITEM_HIST)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">id (PK)
                &nbsp;(<a href="#OrderItem">FK</a>)
              </td><td class="tdTableDefinition">ORDER_ITEM_HIST_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr>
<td colspan="4">
<div class="comment">unique ID of a order item</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">deliveryDate</td><td class="tdTableDefinition">DELIVERY_DATE</td><td class="tdTableDefinition">DATE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">orderItem</td><td class="tdTableDefinition">ORDER_ITEM_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">quantity</td><td class="tdTableDefinition">QUANTITY</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
</table>
<div class="references">
<p class="subTitle">References</p>
<ul>
<li>
<a href="#OrderItem">OrderItem</a> through (id)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>Product<a name="Product"></a>
</h1>
<h2>
      (Physical Name: TBL_PRODUCT)
      </h2>
<p class="comment">Real product information</p>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">id (PK)
                &nbsp;(<a href="#ProductSpecification">FK</a>)
              </td><td class="tdTableDefinition">PRODUCT_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr>
<td colspan="4">
<div class="comment">unique ID of a product</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">name</td><td class="tdTableDefinition">DISPLAY_NAME</td><td class="tdTableDefinition">VARCHAR(200)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">display contact name (full-name if 'invidual')</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">productSpecification</td><td class="tdTableDefinition">PRODUCT_SPEC_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">description</td><td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">VARCHAR(500)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">optional description about this contact</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">producedQuantity</td><td class="tdTableDefinition">PRODUCED_QUANTITY</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">unitPrice</td><td class="tdTableDefinition">UNIT_PRICE</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">unitPriceCurrency</td><td class="tdTableDefinition">UNIT_PRICE_CUR</td><td class="tdTableDefinition">VARCHAR(3)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
</table>
<div class="references">
<p class="subTitle">References</p>
<ul>
<li>
<a href="#ProductSpecification">ProductSpecification</a> through (id)</li>
</ul>
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#OrderItem">OrderItem</a> referencing (id)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>ProductSpecification<a name="ProductSpecification"></a>
</h1>
<h2>
      (Physical Name: TBL_PRODUCT_SPEC)
      </h2>
<p class="comment">product specification</p>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">id (PK)</td><td class="tdTableDefinition">PRODUCT_SPEC_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">name</td><td class="tdTableDefinition">DISPLAY_NAME</td><td class="tdTableDefinition">VARCHAR(200)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">display contact name (full-name if 'invidual')</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">description</td><td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">VARCHAR(500)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">optional description about this contact</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">width</td><td class="tdTableDefinition">BOX_WIDTH</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">height</td><td class="tdTableDefinition">BOX_HEIGHT</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">flattenWidth</td><td class="tdTableDefinition">FLATTEN_WIDTH</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">flattenHeight</td><td class="tdTableDefinition">FLATTEN_HEIGHT</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">area</td><td class="tdTableDefinition">AREA</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">area of the product (i.e. box)</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">paperFormat</td><td class="tdTableDefinition">PAPER_FORMAT</td><td class="tdTableDefinition">VARCHAR(20)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">paperWidth</td><td class="tdTableDefinition">PAPER_WIDTH</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">paper width if paper format is unspecified</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">paperHeight</td><td class="tdTableDefinition">PAPER_HEIGHT</td><td class="tdTableDefinition">DOUBLE</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">paper height if paper format is unspecified</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">length</td><td class="tdTableDefinition">BOX_LENGTH</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">faceSpecification</td><td class="tdTableDefinition">FACE_SPEC</td><td class="tdTableDefinition">VARCHAR(30)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">bottomSpecification</td><td class="tdTableDefinition">BOTTOM_SPEC</td><td class="tdTableDefinition">VARCHAR(30)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
</table>
<div class="references">
<p class="subTitle">Referenced By</p>
<ul>
<li>
<a href="#Product">Product</a> referencing (id)</li>
<li>
<a href="#ProductSpecProperty">ProductSpecProperty</a> referencing (id)</li>
</ul>
</div>
</div>
<div class="tableNameHeading">
<h1>ProductSpecProperty<a name="ProductSpecProperty"></a>
</h1>
<h2>
      (Physical Name: TBL_PROD_SPEC_PROP)
      </h2>
</div>
<div class="table">
<table class="tableDefinition" width="100%">
<tr>
<td class="tdTableHeading tdLogicalColName">Logical Column Name</td><td class="tdTableHeading tdPhysicalColName">Physical Column Name</td><td class="tdTableHeading tdDataType">Type</td><td class="tdTableHeading tdPkFlag">PK</td><td class="tdTableHeading tdNullFlag">Nullable</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">id (PK)
                &nbsp;(<a href="#ProductSpecification">FK</a>)
              </td><td class="tdTableDefinition">PROD_SPEC_PROP_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap>PK</td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">productSpecification</td><td class="tdTableDefinition">PRODUCT_SPEC_ID</td><td class="tdTableDefinition">INTEGER</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">name</td><td class="tdTableDefinition">DISPLAY_NAME</td><td class="tdTableDefinition">VARCHAR(200)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">display contact name (full-name if 'invidual')</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">description</td><td class="tdTableDefinition">DESCRIPTION</td><td class="tdTableDefinition">VARCHAR(500)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">optional description about this contact</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">value</td><td class="tdTableDefinition">PROP_VALUE</td><td class="tdTableDefinition">VARCHAR(500)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap>NOT NULL</td>
</tr>
<tr>
<td colspan="4">
<div class="comment">string presentation of this property's value. This string must be converted to Java Object again.</div>
</td>
</tr>
<tr valign="top">
<td class="tdTableDefinition">dataType</td><td class="tdTableDefinition">PROP_DATA_TYPE</td><td class="tdTableDefinition">VARCHAR(100)</td><td class="tdTableDefinition" nowrap></td><td class="tdTableDefinition" nowrap></td>
</tr>
<tr>
<td colspan="4">
<div class="comment">Data type of this property's value</div>
</td>
</tr>
</table>
<div class="references">
<p class="subTitle">References</p>
<ul>
<li>
<a href="#ProductSpecification">ProductSpecification</a> through (id)</li>
</ul>
</div>
</div>
</body>
</html>
